Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 344667 |
| Missing cells | 54376 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 36.8 MiB |
| Average record size in memory | 112.0 B |
Variable types
| Categorical | 1 |
|---|---|
| DateTime | 3 |
| Numeric | 9 |
| Text | 1 |
VERSIE has constant value "" | Constant |
DATUM_BESTAND has constant value "" | Constant |
PEILDATUM has constant value "" | Constant |
BEHANDELEND_SPECIALISME_CD is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
AANTAL_PAT_PER_ZPD is highly overall correlated with AANTAL_SUBTRAJECT_PER_ZPD | High correlation |
AANTAL_SUBTRAJECT_PER_ZPD is highly overall correlated with AANTAL_PAT_PER_ZPD | High correlation |
AANTAL_PAT_PER_DIAG is highly overall correlated with AANTAL_SUBTRAJECT_PER_DIAG | High correlation |
AANTAL_SUBTRAJECT_PER_DIAG is highly overall correlated with AANTAL_PAT_PER_DIAG | High correlation |
AANTAL_PAT_PER_SPC is highly overall correlated with BEHANDELEND_SPECIALISME_CD and 1 other fields | High correlation |
AANTAL_SUBTRAJECT_PER_SPC is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
GEMIDDELDE_VERKOOPPRIJS has 54376 (15.8%) missing values | Missing |
AANTAL_SUBTRAJECT_PER_ZPD is highly skewed (γ1 = 21.44671209) | Skewed |
Reproduction
| Analysis started | 2023-10-24 11:45:46.174008 |
|---|---|
| Analysis finished | 2023-10-24 11:46:16.374527 |
| Duration | 30.2 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
VERSIE
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1034001 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 344667 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 344667 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 344667 | |
| . | 344667 | |
| 0 | 344667 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 689334 | |
| Other Punctuation | 344667 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 344667 | |
| 0 | 344667 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 344667 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1034001 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 344667 | |
| . | 344667 | |
| 0 | 344667 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1034001 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 344667 | |
| . | 344667 | |
| 0 | 344667 |
DATUM_BESTAND
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| Minimum | 2023-10-13 00:00:00 |
|---|---|
| Maximum | 2023-10-13 00:00:00 |
Histogram with fixed size bins (bins=1)
PEILDATUM
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| Minimum | 2023-10-01 00:00:00 |
|---|---|
| Maximum | 2023-10-01 00:00:00 |
Histogram with fixed size bins (bins=1)
JAAR
Date
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| Minimum | 2012-01-01 00:00:00 |
|---|---|
| Maximum | 2023-01-01 00:00:00 |
Histogram with fixed size bins (bins=12)
BEHANDELEND_SPECIALISME_CD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 450.14325 |
| Minimum | 301 |
|---|---|
| Maximum | 8418 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 301 |
|---|---|
| 5-th percentile | 302 |
| Q1 | 305 |
| median | 313 |
| Q3 | 322 |
| 95-th percentile | 361 |
| Maximum | 8418 |
| Range | 8117 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 1035.5711 |
|---|---|
| Coefficient of variation (CV) | 2.3005369 |
| Kurtosis | 55.115055 |
| Mean | 450.14325 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 7.5525808 |
| Sum | 1.5514952 × 108 |
| Variance | 1072407.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 305 | 48306 | |
| 313 | 44792 | |
| 303 | 39617 | |
| 330 | 27217 | 7.9% |
| 316 | 23431 | 6.8% |
| 308 | 18578 | 5.4% |
| 306 | 14481 | 4.2% |
| 324 | 14138 | 4.1% |
| 301 | 13812 | 4.0% |
| 304 | 11232 | 3.3% |
| Other values (18) | 89063 |
| Value | Count | Frequency (%) |
| 301 | 13812 | 4.0% |
| 302 | 7591 | 2.2% |
| 303 | 39617 | |
| 304 | 11232 | 3.3% |
| 305 | 48306 | |
| 306 | 14481 | 4.2% |
| 307 | 6059 | 1.8% |
| 308 | 18578 | 5.4% |
| 310 | 3774 | 1.1% |
| 313 | 44792 |
| Value | Count | Frequency (%) |
| 8418 | 4665 | 1.4% |
| 8416 | 1051 | 0.3% |
| 1900 | 229 | 0.1% |
| 390 | 951 | 0.3% |
| 389 | 3613 | 1.0% |
| 362 | 4440 | 1.3% |
| 361 | 2509 | 0.7% |
| 335 | 3485 | 1.0% |
| 330 | 27217 | |
| 329 | 904 | 0.3% |
| Distinct | 1902 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.352372 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1155452 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 10 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 998 |
|---|---|
| 2nd row | 014 |
| 3rd row | 120 |
| 4th row | 044 |
| 5th row | 015 |
| Value | Count | Frequency (%) |
| 101 | 1473 | 0.4% |
| 402 | 1418 | 0.4% |
| 403 | 1392 | 0.4% |
| 301 | 1389 | 0.4% |
| 201 | 1311 | 0.4% |
| 203 | 1287 | 0.4% |
| 401 | 1159 | 0.3% |
| 404 | 1147 | 0.3% |
| 409 | 1120 | 0.3% |
| 802 | 1118 | 0.3% |
| Other values (1892) | 331853 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 220941 | |
| 0 | 212332 | |
| 2 | 153115 | |
| 3 | 125060 | |
| 5 | 89094 | |
| 9 | 83186 | 7.2% |
| 4 | 81859 | 7.1% |
| 7 | 68060 | 5.9% |
| 6 | 60341 | 5.2% |
| 8 | 49768 | 4.3% |
| Other values (15) | 11696 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1143756 | |
| Uppercase Letter | 11696 | 1.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 2183 | |
| M | 1966 | |
| B | 1421 | |
| Z | 1011 | |
| E | 982 | |
| D | 767 | 6.6% |
| A | 756 | 6.5% |
| F | 726 | 6.2% |
| C | 385 | 3.3% |
| K | 377 | 3.2% |
| Other values (5) | 1122 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 220941 | |
| 0 | 212332 | |
| 2 | 153115 | |
| 3 | 125060 | |
| 5 | 89094 | |
| 9 | 83186 | 7.3% |
| 4 | 81859 | 7.2% |
| 7 | 68060 | 6.0% |
| 6 | 60341 | 5.3% |
| 8 | 49768 | 4.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1143756 | |
| Latin | 11696 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 2183 | |
| M | 1966 | |
| B | 1421 | |
| Z | 1011 | |
| E | 982 | |
| D | 767 | 6.6% |
| A | 756 | 6.5% |
| F | 726 | 6.2% |
| C | 385 | 3.3% |
| K | 377 | 3.2% |
| Other values (5) | 1122 |
Common
| Value | Count | Frequency (%) |
| 1 | 220941 | |
| 0 | 212332 | |
| 2 | 153115 | |
| 3 | 125060 | |
| 5 | 89094 | |
| 9 | 83186 | 7.3% |
| 4 | 81859 | 7.2% |
| 7 | 68060 | 6.0% |
| 6 | 60341 | 5.3% |
| 8 | 49768 | 4.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1155452 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 220941 | |
| 0 | 212332 | |
| 2 | 153115 | |
| 3 | 125060 | |
| 5 | 89094 | |
| 9 | 83186 | 7.2% |
| 4 | 81859 | 7.1% |
| 7 | 68060 | 5.9% |
| 6 | 60341 | 5.2% |
| 8 | 49768 | 4.3% |
| Other values (15) | 11696 | 1.0% |
ZORGPRODUCT_CD
Real number (ℝ)
| Distinct | 6188 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.4091611 × 108 |
| Minimum | 10501002 |
|---|---|
| Maximum | 9.9841808 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 10501002 |
|---|---|
| 5-th percentile | 28999040 |
| Q1 | 99799062 |
| median | 1.4959903 × 108 |
| Q3 | 9.90004 × 108 |
| 95-th percentile | 9.9051605 × 108 |
| Maximum | 9.9841808 × 108 |
| Range | 9.8791708 × 108 |
| Interquartile range (IQR) | 8.9020494 × 108 |
Descriptive statistics
| Standard deviation | 4.2900936 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.97299543 |
| Kurtosis | -1.7379537 |
| Mean | 4.4091611 × 108 |
| Median Absolute Deviation (MAD) | 1.1960002 × 108 |
| Skewness | 0.46699649 |
| Sum | 1.5196923 × 1014 |
| Variance | 1.8404904 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 990004009 | 2531 | 0.7% |
| 990004007 | 2482 | 0.7% |
| 990003004 | 2382 | 0.7% |
| 990004006 | 2007 | 0.6% |
| 990356076 | 1838 | 0.5% |
| 990356073 | 1705 | 0.5% |
| 131999228 | 1688 | 0.5% |
| 131999164 | 1664 | 0.5% |
| 990003007 | 1543 | 0.4% |
| 131999194 | 1514 | 0.4% |
| Other values (6178) | 325313 |
| Value | Count | Frequency (%) |
| 10501002 | 9 | |
| 10501003 | 12 | |
| 10501004 | 12 | |
| 10501005 | 12 | |
| 10501007 | 3 | < 0.1% |
| 10501008 | 12 | |
| 10501010 | 12 | |
| 10501011 | 3 | < 0.1% |
| 11101002 | 11 | |
| 11101003 | 12 |
| Value | Count | Frequency (%) |
| 998418081 | 173 | |
| 998418080 | 155 | |
| 998418079 | 39 | < 0.1% |
| 998418077 | 9 | < 0.1% |
| 998418076 | 9 | < 0.1% |
| 998418075 | 7 | < 0.1% |
| 998418074 | 238 | |
| 998418073 | 241 | |
| 998418072 | 9 | < 0.1% |
| 998418071 | 9 | < 0.1% |
AANTAL_PAT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10412 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 510.09835 |
| Minimum | 1 |
|---|---|
| Maximum | 165184 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 13 |
| Q3 | 101 |
| 95-th percentile | 1718 |
| Maximum | 165184 |
| Range | 165183 |
| Interquartile range (IQR) | 98 |
Descriptive statistics
| Standard deviation | 3179.7084 |
|---|---|
| Coefficient of variation (CV) | 6.2335203 |
| Kurtosis | 416.13682 |
| Mean | 510.09835 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 16.88559 |
| Sum | 1.7581407 × 108 |
| Variance | 10110546 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 57359 | 16.6% |
| 2 | 27978 | 8.1% |
| 3 | 18271 | 5.3% |
| 4 | 13358 | 3.9% |
| 5 | 10464 | 3.0% |
| 6 | 8826 | 2.6% |
| 7 | 7395 | 2.1% |
| 8 | 6196 | 1.8% |
| 9 | 5648 | 1.6% |
| 10 | 5053 | 1.5% |
| Other values (10402) | 184119 |
| Value | Count | Frequency (%) |
| 1 | 57359 | |
| 2 | 27978 | |
| 3 | 18271 | 5.3% |
| 4 | 13358 | 3.9% |
| 5 | 10464 | 3.0% |
| 6 | 8826 | 2.6% |
| 7 | 7395 | 2.1% |
| 8 | 6196 | 1.8% |
| 9 | 5648 | 1.6% |
| 10 | 5053 | 1.5% |
| Value | Count | Frequency (%) |
| 165184 | 1 | |
| 162458 | 1 | |
| 157193 | 1 | |
| 155869 | 1 | |
| 154539 | 1 | |
| 154258 | 1 | |
| 144714 | 1 | |
| 118396 | 1 | |
| 115935 | 1 | |
| 113246 | 1 |
AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 11189 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 604.64298 |
| Minimum | 1 |
|---|---|
| Maximum | 240002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 14 |
| Q3 | 111 |
| 95-th percentile | 1965 |
| Maximum | 240002 |
| Range | 240001 |
| Interquartile range (IQR) | 108 |
Descriptive statistics
| Standard deviation | 4104.0529 |
|---|---|
| Coefficient of variation (CV) | 6.7875641 |
| Kurtosis | 728.94494 |
| Mean | 604.64298 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 21.446712 |
| Sum | 2.0840048 × 108 |
| Variance | 16843251 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 55257 | 16.0% |
| 2 | 27501 | 8.0% |
| 3 | 18088 | 5.2% |
| 4 | 13149 | 3.8% |
| 5 | 10403 | 3.0% |
| 6 | 8787 | 2.5% |
| 7 | 7323 | 2.1% |
| 8 | 6139 | 1.8% |
| 9 | 5560 | 1.6% |
| 10 | 5058 | 1.5% |
| Other values (11179) | 187402 |
| Value | Count | Frequency (%) |
| 1 | 55257 | |
| 2 | 27501 | |
| 3 | 18088 | 5.2% |
| 4 | 13149 | 3.8% |
| 5 | 10403 | 3.0% |
| 6 | 8787 | 2.5% |
| 7 | 7323 | 2.1% |
| 8 | 6139 | 1.8% |
| 9 | 5560 | 1.6% |
| 10 | 5058 | 1.5% |
| Value | Count | Frequency (%) |
| 240002 | 1 | |
| 232423 | 1 | |
| 231954 | 1 | |
| 230940 | 1 | |
| 227936 | 1 | |
| 227409 | 1 | |
| 226321 | 1 | |
| 223891 | 1 | |
| 218673 | 1 | |
| 215131 | 1 |
AANTAL_PAT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 9333 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7647.0367 |
| Minimum | 1 |
|---|---|
| Maximum | 230661 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 39 |
| Q1 | 389 |
| median | 1682 |
| Q3 | 6216 |
| 95-th percentile | 36610 |
| Maximum | 230661 |
| Range | 230660 |
| Interquartile range (IQR) | 5827 |
Descriptive statistics
| Standard deviation | 17904.334 |
|---|---|
| Coefficient of variation (CV) | 2.3413427 |
| Kurtosis | 34.97096 |
| Mean | 7647.0367 |
| Median Absolute Deviation (MAD) | 1540 |
| Skewness | 5.1197928 |
| Sum | 2.6356812 × 109 |
| Variance | 3.2056517 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21 | 579 | 0.2% |
| 8 | 547 | 0.2% |
| 9 | 523 | 0.2% |
| 17 | 515 | 0.1% |
| 12 | 513 | 0.1% |
| 23 | 510 | 0.1% |
| 26 | 497 | 0.1% |
| 6 | 496 | 0.1% |
| 25 | 493 | 0.1% |
| 20 | 485 | 0.1% |
| Other values (9323) | 339509 |
| Value | Count | Frequency (%) |
| 1 | 423 | |
| 2 | 472 | |
| 3 | 478 | |
| 4 | 463 | |
| 5 | 457 | |
| 6 | 496 | |
| 7 | 465 | |
| 8 | 547 | |
| 9 | 523 | |
| 10 | 451 |
| Value | Count | Frequency (%) |
| 230661 | 23 | |
| 228042 | 19 | |
| 227999 | 23 | |
| 218496 | 24 | |
| 214507 | 17 | |
| 213515 | 25 | |
| 211579 | 17 | |
| 210415 | 19 | |
| 205337 | 17 | |
| 200600 | 16 |
AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10455 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11090.71 |
| Minimum | 1 |
|---|---|
| Maximum | 370139 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 50 |
| Q1 | 513 |
| median | 2334 |
| Q3 | 9027 |
| 95-th percentile | 52174 |
| Maximum | 370139 |
| Range | 370138 |
| Interquartile range (IQR) | 8514 |
Descriptive statistics
| Standard deviation | 26871.928 |
|---|---|
| Coefficient of variation (CV) | 2.4229222 |
| Kurtosis | 38.272683 |
| Mean | 11090.71 |
| Median Absolute Deviation (MAD) | 2148 |
| Skewness | 5.350783 |
| Sum | 3.8226019 × 109 |
| Variance | 7.2210053 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13 | 444 | 0.1% |
| 23 | 434 | 0.1% |
| 6 | 424 | 0.1% |
| 20 | 420 | 0.1% |
| 25 | 418 | 0.1% |
| 10 | 417 | 0.1% |
| 31 | 416 | 0.1% |
| 3 | 415 | 0.1% |
| 17 | 402 | 0.1% |
| 8 | 401 | 0.1% |
| Other values (10445) | 340476 |
| Value | Count | Frequency (%) |
| 1 | 339 | |
| 2 | 355 | |
| 3 | 415 | |
| 4 | 393 | |
| 5 | 366 | |
| 6 | 424 | |
| 7 | 371 | |
| 8 | 401 | |
| 9 | 321 | |
| 10 | 417 |
| Value | Count | Frequency (%) |
| 370139 | 23 | |
| 365373 | 23 | |
| 348482 | 25 | |
| 347952 | 19 | |
| 344610 | 24 | |
| 341651 | 19 | |
| 323753 | 20 | |
| 315771 | 17 | |
| 310754 | 17 | |
| 298627 | 17 |
AANTAL_PAT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 325 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 664855.73 |
| Minimum | 1610 |
|---|---|
| Maximum | 1487633 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1610 |
|---|---|
| 5-th percentile | 42174 |
| Q1 | 256043 |
| median | 757852 |
| Q3 | 1026299 |
| 95-th percentile | 1332325 |
| Maximum | 1487633 |
| Range | 1486023 |
| Interquartile range (IQR) | 770256 |
Descriptive statistics
| Standard deviation | 420832.51 |
|---|---|
| Coefficient of variation (CV) | 0.63296816 |
| Kurtosis | -1.1915636 |
| Mean | 664855.73 |
| Median Absolute Deviation (MAD) | 319272 |
| Skewness | 0.0031163395 |
| Sum | 2.2915383 × 1011 |
| Variance | 1.771 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 880929 | 5102 | 1.5% |
| 874089 | 4354 | 1.3% |
| 843977 | 4347 | 1.3% |
| 894305 | 4333 | 1.3% |
| 880466 | 4273 | 1.2% |
| 897701 | 4212 | 1.2% |
| 765010 | 4089 | 1.2% |
| 803534 | 4027 | 1.2% |
| 777934 | 3984 | 1.2% |
| 1029429 | 3893 | 1.1% |
| Other values (315) | 302053 |
| Value | Count | Frequency (%) |
| 1610 | 130 | < 0.1% |
| 1829 | 138 | < 0.1% |
| 1920 | 131 | < 0.1% |
| 2495 | 173 | |
| 2507 | 95 | < 0.1% |
| 2520 | 190 | |
| 3561 | 67 | < 0.1% |
| 4101 | 168 | |
| 4842 | 312 | |
| 6805 | 380 |
| Value | Count | Frequency (%) |
| 1487633 | 2975 | |
| 1450392 | 3048 | |
| 1421705 | 3564 | |
| 1344277 | 3543 | |
| 1340587 | 3441 | |
| 1332325 | 3545 | |
| 1316373 | 3463 | |
| 1282936 | 3576 | |
| 1268857 | 3359 | |
| 1267069 | 3350 |
AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 325 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1079684 |
| Minimum | 1861 |
|---|---|
| Maximum | 2664317 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1861 |
|---|---|
| 5-th percentile | 46350 |
| Q1 | 365047 |
| median | 1106917 |
| Q3 | 1790741 |
| 95-th percentile | 2548229 |
| Maximum | 2664317 |
| Range | 2662456 |
| Interquartile range (IQR) | 1425694 |
Descriptive statistics
| Standard deviation | 756307.5 |
|---|---|
| Coefficient of variation (CV) | 0.70048967 |
| Kurtosis | -0.8457335 |
| Mean | 1079684 |
| Median Absolute Deviation (MAD) | 703648 |
| Skewness | 0.35759607 |
| Sum | 3.7213145 × 1011 |
| Variance | 5.7200103 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1211797 | 5102 | 1.5% |
| 1281483 | 4354 | 1.3% |
| 1216255 | 4347 | 1.3% |
| 1315566 | 4333 | 1.3% |
| 1300429 | 4273 | 1.2% |
| 1341823 | 4212 | 1.2% |
| 1155927 | 4089 | 1.2% |
| 1205463 | 4027 | 1.2% |
| 1148265 | 3984 | 1.2% |
| 2491870 | 3893 | 1.1% |
| Other values (315) | 302053 |
| Value | Count | Frequency (%) |
| 1861 | 130 | < 0.1% |
| 2097 | 138 | < 0.1% |
| 2195 | 131 | < 0.1% |
| 2628 | 95 | < 0.1% |
| 2816 | 173 | |
| 3288 | 190 | |
| 3717 | 67 | < 0.1% |
| 4898 | 312 | |
| 4904 | 168 | |
| 7384 | 380 |
| Value | Count | Frequency (%) |
| 2664317 | 3866 | |
| 2663203 | 3793 | |
| 2618705 | 3789 | |
| 2593574 | 3844 | |
| 2548229 | 3890 | |
| 2491870 | 3893 | |
| 2480004 | 3851 | |
| 2178538 | 3757 | |
| 2062186 | 3811 | |
| 2052149 | 1168 | 0.3% |
GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)
MISSING
| Distinct | 3632 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 54376 |
| Missing (%) | 15.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3582.5327 |
| Minimum | 70 |
|---|---|
| Maximum | 287220 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 70 |
|---|---|
| 5-th percentile | 140 |
| Q1 | 475 |
| median | 1240 |
| Q3 | 4155 |
| 95-th percentile | 13620 |
| Maximum | 287220 |
| Range | 287150 |
| Interquartile range (IQR) | 3680 |
Descriptive statistics
| Standard deviation | 6522.7528 |
|---|---|
| Coefficient of variation (CV) | 1.8207099 |
| Kurtosis | 139.45158 |
| Mean | 3582.5327 |
| Median Absolute Deviation (MAD) | 1015 |
| Skewness | 7.0338726 |
| Sum | 1.039977 × 109 |
| Variance | 42546304 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 160 | 2098 | 0.6% |
| 105 | 1942 | 0.6% |
| 110 | 1818 | 0.5% |
| 185 | 1768 | 0.5% |
| 180 | 1604 | 0.5% |
| 300 | 1588 | 0.5% |
| 140 | 1512 | 0.4% |
| 175 | 1489 | 0.4% |
| 125 | 1381 | 0.4% |
| 165 | 1375 | 0.4% |
| Other values (3622) | 273716 | |
| (Missing) | 54376 | 15.8% |
| Value | Count | Frequency (%) |
| 70 | 226 | 0.1% |
| 75 | 75 | < 0.1% |
| 80 | 362 | 0.1% |
| 85 | 919 | |
| 90 | 663 | 0.2% |
| 95 | 734 | 0.2% |
| 100 | 1015 | |
| 105 | 1942 | |
| 110 | 1818 | |
| 115 | 1147 |
| Value | Count | Frequency (%) |
| 287220 | 8 | |
| 148910 | 3 | < 0.1% |
| 142835 | 4 | |
| 122155 | 4 | |
| 116765 | 3 | < 0.1% |
| 109725 | 7 | |
| 108570 | 7 | |
| 107655 | 4 | |
| 101270 | 8 | |
| 99590 | 5 |
| BEHANDELEND_SPECIALISME_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|
| BEHANDELEND_SPECIALISME_CD | 1.000 | 0.215 | 0.007 | 0.012 | -0.061 | -0.055 | -0.535 | -0.457 | 0.050 |
| ZORGPRODUCT_CD | 0.215 | 1.000 | -0.139 | -0.148 | -0.176 | -0.207 | -0.363 | -0.389 | 0.029 |
| AANTAL_PAT_PER_ZPD | 0.007 | -0.139 | 1.000 | 0.996 | 0.327 | 0.325 | 0.084 | 0.093 | -0.299 |
| AANTAL_SUBTRAJECT_PER_ZPD | 0.012 | -0.148 | 0.996 | 1.000 | 0.323 | 0.326 | 0.087 | 0.100 | -0.301 |
| AANTAL_PAT_PER_DIAG | -0.061 | -0.176 | 0.327 | 0.323 | 1.000 | 0.988 | 0.341 | 0.324 | 0.032 |
| AANTAL_SUBTRAJECT_PER_DIAG | -0.055 | -0.207 | 0.325 | 0.326 | 0.988 | 1.000 | 0.359 | 0.357 | 0.041 |
| AANTAL_PAT_PER_SPC | -0.535 | -0.363 | 0.084 | 0.087 | 0.341 | 0.359 | 1.000 | 0.964 | -0.006 |
| AANTAL_SUBTRAJECT_PER_SPC | -0.457 | -0.389 | 0.093 | 0.100 | 0.324 | 0.357 | 0.964 | 1.000 | -0.009 |
| GEMIDDELDE_VERKOOPPRIJS | 0.050 | 0.029 | -0.299 | -0.301 | 0.032 | 0.041 | -0.006 | -0.009 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.0 | 2023-10-13 | 2023-10-01 | 2013-01-01 | 389 | 998 | 990089076 | 4 | 4 | 12805 | 13490 | 197275 | 284602 | NaN |
| 1 | 1.0 | 2023-10-13 | 2023-10-01 | 2013-01-01 | 389 | 014 | 990089093 | 391 | 442 | 733 | 1055 | 197275 | 284602 | 250.0 |
| 2 | 1.0 | 2023-10-13 | 2023-10-01 | 2013-01-01 | 389 | 120 | 990089032 | 5 | 11 | 932 | 1353 | 197275 | 284602 | NaN |
| 3 | 1.0 | 2023-10-13 | 2023-10-01 | 2013-01-01 | 389 | 044 | 990089009 | 4 | 4 | 4883 | 7511 | 197275 | 284602 | 20760.0 |
| 4 | 1.0 | 2023-10-13 | 2023-10-01 | 2013-01-01 | 389 | 015 | 990089060 | 106 | 126 | 923 | 1314 | 197275 | 284602 | 1125.0 |
| 5 | 1.0 | 2023-10-13 | 2023-10-01 | 2013-01-01 | 389 | 150 | 990089055 | 29 | 33 | 3451 | 4788 | 197275 | 284602 | 2560.0 |
| 6 | 1.0 | 2023-10-13 | 2023-10-01 | 2013-01-01 | 389 | 130 | 990089031 | 1759 | 2238 | 13218 | 19374 | 197275 | 284602 | 1075.0 |
| 7 | 1.0 | 2023-10-13 | 2023-10-01 | 2013-01-01 | 389 | 990 | 990040006 | 8 | 8 | 734 | 782 | 197275 | 284602 | NaN |
| 8 | 1.0 | 2023-10-13 | 2023-10-01 | 2013-01-01 | 389 | 042 | 990089051 | 5 | 5 | 6064 | 8592 | 197275 | 284602 | NaN |
| 9 | 1.0 | 2023-10-13 | 2023-10-01 | 2013-01-01 | 389 | 999 | 990089009 | 1 | 1 | 2914 | 3345 | 197275 | 284602 | 20760.0 |
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 344657 | 1.0 | 2023-10-13 | 2023-10-01 | 2014-01-01 | 303 | 134 | 131999072 | 1 | 1 | 4758 | 5631 | 1421705 | 1845625 | 3315.0 |
| 344658 | 1.0 | 2023-10-13 | 2023-10-01 | 2014-01-01 | 303 | 117 | 119499036 | 11 | 11 | 35572 | 51722 | 1421705 | 1845625 | 2875.0 |
| 344659 | 1.0 | 2023-10-13 | 2023-10-01 | 2014-01-01 | 303 | 299 | 199299052 | 1 | 1 | 32521 | 33557 | 1421705 | 1845625 | NaN |
| 344660 | 1.0 | 2023-10-13 | 2023-10-01 | 2014-01-01 | 303 | 358 | 20112018 | 3 | 3 | 13 | 15 | 1421705 | 1845625 | 290.0 |
| 344661 | 1.0 | 2023-10-13 | 2023-10-01 | 2014-01-01 | 303 | 705 | 979004014 | 1 | 1 | 13 | 16 | 1421705 | 1845625 | NaN |
| 344662 | 1.0 | 2023-10-13 | 2023-10-01 | 2020-01-01 | 320 | 803 | 979001243 | 1 | 1 | 50023 | 75135 | 1030982 | 1831086 | 21035.0 |
| 344663 | 1.0 | 2023-10-13 | 2023-10-01 | 2014-01-01 | 303 | 222 | 199299080 | 1 | 1 | 7666 | 9519 | 1421705 | 1845625 | 4085.0 |
| 344664 | 1.0 | 2023-10-13 | 2023-10-01 | 2020-01-01 | 313 | 799 | 979003016 | 1 | 1 | 2069 | 3014 | 1047006 | 2618705 | 15985.0 |
| 344665 | 1.0 | 2023-10-13 | 2023-10-01 | 2014-01-01 | 303 | 334 | 990003007 | 1 | 1 | 7963 | 9879 | 1421705 | 1845625 | 105.0 |
| 344666 | 1.0 | 2023-10-13 | 2023-10-01 | 2014-01-01 | 303 | 367 | 29199222 | 1 | 1 | 2862 | 3901 | 1421705 | 1845625 | NaN |